<?php
	session_start();

	if(isset($_SESSION['authorised']) && $_SESSION['authorised'] == true)
	{   
    	if(isset($_SESSION['type']))
    	{
        	if($_SESSION['type'] == 'administrator')
        	{
            	header('Location: admin_index.php');
            	exit();
        	}
		    elseif($_SESSION['type'] == 'student')
		     {
		        header('Location: student_index.php');
		        exit();
		    }
		    elseif($_SESSION['type'] == 'tutor')
		    {
		        header('Location: tutor_index.php');
		        exit();
		    }
		    elseif($_SESSION['type'] == 'parent')
		    {
		    $host = 'localhost';
			$dbuser = 'postgres';
			$dbpass = 'password';
			$dbname = $_SESSION['database'];
			$username = $_SESSION['user'];
			
			pg_connect("host=$host user=$dbuser password=$dbpass dbname=$dbname") or die(pg_last_error());
			
			?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Reservations</title>
<link href="StyleSheet.css" rel="stylesheet" type="text/css" />
<style>
.nav {
	width: 210px;
	height: auto;
	margin-left: 10px;
	text-align: center;
}

.mainline {
	width: 712px;
	height: auto;
	text-align: center;
}
</style>
</head>

<body bgcolor="#FFFFFF">
	<center>
		<div id="wrapper">
			<div id="header">
				<h1></h1>
			</div>

			<div id="header2">
				<h3></h3>
			</div>

			<div id="nav">
				<?php include 'parent_navigation.php';?>
			</div>

			<div id="mainline">
				<h4>Reserve</h4>
			</div>

			<div id="body">
				<?php
					if(isset($_SESSION['message']) && $_SESSION['message'] != ""){
						$message = $_SESSION['message'];
						echo "<i>$message<i><br>";
						unset($_SESSION['message']);
					}
				?>
				<center>
				<form action=parent_actionreserve.php method=POST>	
				    <p><b>Enter Class ID to reserve: </b><input name="classid" id="classid"  maxlength="50"/><input type = "submit" value ="Submit" /></p>
				    <br>
					<table width="700" height="auto"  cellpadding="3" cellspacing="1">
						<tr height="40" bgcolor="LightSteelBlue" alignment="right" >
						    <th width="100">Subject/Section</th>
						    <th width="50">Class ID</th>
							<th width="150">Schedule</th>
							<th width="75">Room</th>
							<th width="150">Instructor</th>
							<th width="175">Start/End Date</th>
						</tr>
					 	<?php 
						$sql = "select * from classes natural inner join rooms where class_id not in (select class_id from reservations where username = 'parent') AND for_reservation='t'"; //classes na hindi zero yung available slots and hindi pa nareserve ni parent	
						$result = pg_query($sql);
						$count = pg_num_rows($result);
						
						if ($count == 0) {
							echo "</table><br />There are no classes to reserve.";
						}
						
						for($i = 0; $i < $count; $i++)
						{   
							$class_subj = pg_fetch_result($result,$i, 'subject');
							$class_id = pg_fetch_result($result,$i, 'class_id');
							$section = pg_fetch_result($result,$i, 'section');
							$tutor = pg_fetch_result($result, $i, 'teacher_id');
							$start_date = pg_fetch_result($result, $i, 'startdate');
			                $time = date_create_from_format('Y-m-d', $start_date);
			                $startdate= date_format($time, 'M-d-Y');
							
							$end_date = pg_fetch_result($result, $i, 'enddate');
							$time = date_create_from_format('Y-m-d', $end_date);
			                $enddate= date_format($time, 'M-d-Y');
							$room = pg_fetch_result($result, 'room_id');
							$starttime= pg_fetch_result($result, 'starttime');
							$endtime= pg_fetch_result($result, 'endtime');
							$sql2 = "SELECT * FROM teachers natural join users where teacher_id='$tutor'";
		           			$result1 = pg_query($sql2);
		           			$lastname = pg_fetch_result($result1, 0, 'lastname');
		           			$firstname = pg_fetch_result($result1, 0, 'firstname');
			                echo "<tr height=\"30\" bgcolor=\"#f5f5f5\">
								<td align=\"center\">$class_subj / $section</td>
								<td align=\"center\">$class_id</td>
								<td align=\"center\">$starttime - $endtime</td>
								<td align=\"center\">$room</td>
								<td align=\"center\">$lastname, $firstname</td>
								<td align=\"center\">$startdate to $enddate</td>
							</tr>";
						}
						?>
						</table>
				</form>
				</center>

			</div>

			<p align="justify">
				<br />
			</p>
		

		<br class="clearfloat"> <br />

		<div id="footer">
			<p align="center">
				Tutorial Business Manager: info@tbms.com <br />Credits/Engineers:
				Aquino, Chloebelle; Dela Cruz, Roy Erwin; Maliwanag, Ranyel Bryan;
				Manzano, Audrey Ann; Ng, Sheila Regine<br /> <br />copyright 2011
			</p>
		</div>
		</div>
	</center>
</body>

<?php
			}
   	 	}
	}
	else
	{
  		header('Location: index.php');
	}
?>
